package com.site.service;

import com.site.pojo.EmployeeRole;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface EmployeeRoleService {
    /*查询所有员工的角色*/
    List<EmployeeRole> selectAll() throws SQLException;

    /*根据员工id查询员工角色*/
    EmployeeRole selectById(EmployeeRole emp) throws SQLException;

    /*添加员工的角色*/
    boolean addEmployeeRole(Connection con, EmployeeRole employeeRole) throws SQLException;

    /*删除员工的角色*/
    boolean delEmployeeRole(Connection con, EmployeeRole employeeRole);

    /*修改员工的角色*/
    boolean updateEmployeeRole(Connection con, EmployeeRole employeeRole);


}
